package org.dromara.system.mapper;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.dromara.common.mybatis.core.page.PageQuery;
import org.dromara.system.domain.WbCompanyBlacklist;
import org.dromara.system.domain.dto.WbCompanyBlacklistCountProductDTO;
import org.dromara.system.domain.dto.WbCompanyBlacklistCountProvinceDTO;
import org.dromara.system.domain.vo.WbCompanyBlacklistVo;
import org.dromara.common.mybatis.core.mapper.BaseMapperPlus;

import java.util.List;

/**
 * 企业黑名单Mapper接口
 *
 * @author Lion Li
 * @date 2024-03-22
 */
public interface WbCompanyBlacklistMapper extends BaseMapperPlus<WbCompanyBlacklist, WbCompanyBlacklistVo> {


    int insertExcelList(List<WbCompanyBlacklist> tbZbzsList);


    Integer queryListSum(Long companyId);

    void updateAllList(List<String> updateCityList);

    WbCompanyBlacklistCountProvinceDTO queryCountProvince(Long provinceId);

    List<WbCompanyBlacklistCountProductDTO> queryCountProduct(String disposeWay);

    Page<WbCompanyBlacklistVo> pagerCompanyBlacklistCount(@Param("page") Page<Object> build, @Param(Constants.WRAPPER) LambdaQueryWrapper<WbCompanyBlacklist> lqw);

    List<WbCompanyBlacklistVo> pagerCompanyBlacklistCount( @Param(Constants.WRAPPER) LambdaQueryWrapper<WbCompanyBlacklist> ew);

    Page<WbCompanyBlacklistVo> selectVoPageZdy(@Param("page") Page<Object> build, @Param(Constants.WRAPPER)LambdaQueryWrapper<WbCompanyBlacklist> ew);

    Page<WbCompanyBlacklistVo> selectVoPageXcx(@Param("page") Page<Object> build, @Param(Constants.WRAPPER)LambdaQueryWrapper<WbCompanyBlacklist> ew);

    Page<WbCompanyBlacklistVo> queryBlackOne(@Param("page") Page<Object> build,String companyName ,String blacklistStatus);
}
